[ROOT] dt FactResellerSale < WHERE DimPromotionId EQ '9' >
61 items
FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SO46607_3 | C1B5-40D6-8D | PO18444137892 | 19 | 291 | 327 | 9 | 227 | 6 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 3 | SO46607 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46614_10 | 0B65-4374-89 | PO15312137226 | 19 | 291 | 327 | 9 | 299 | 6 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 10 | SO46614 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46616_4 | 1264-43E6-B7 | PO14732122562 | 19 | 291 | 327 | 9 | 514 | 6 | 916.10 | 2022-04-18 | 3053.66 | 53.44 | 2022-04-06 | 13 | 486.71 | 1 | 2137.56 | 4 | SO46616 | 2022-04-13 | 171.01 | 6327.19 | 234.90 | 0.30 |
SO46617_5 | 3FDB-4564-98 | PO14413119944 | 100 | 287 | 327 | 9 | 383 | 4 | 281.88 | 2022-04-18 | 939.59 | 16.44 | 2022-04-06 | 4 | 486.71 | 1 | 657.71 | 5 | SO46617 | 2022-04-13 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO46620_38 | FEE3-4994-8E | PO13775143788 | 100 | 281 | 327 | 9 | 618 | 2 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 38 | SO46620 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46621_8 | DCA1-4F74-BD | PO13949117076 | 100 | 281 | 327 | 9 | 643 | 3 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 8 | SO46621 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46629_26 | E8D3-4649-8A | PO12412165004 | 100 | 283 | 327 | 9 | 670 | 3 | 422.81 | 2022-04-18 | 1409.38 | 24.66 | 2022-04-06 | 6 | 486.71 | 1 | 986.57 | 26 | SO46629 | 2022-04-13 | 78.93 | 2920.24 | 234.90 | 0.30 |
SO46634_2 | 8EF9-46A8-AA | PO10730130024 | 100 | 287 | 327 | 9 | 491 | 4 | 70.47 | 2022-04-18 | 234.90 | 4.11 | 2022-04-06 | 1 | 486.71 | 1 | 164.43 | 2 | SO46634 | 2022-04-13 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46638_18 | 9659-44CE-A2 | PO10817110834 | 100 | 287 | 327 | 9 | 203 | 4 | 140.94 | 2022-04-18 | 469.79 | 8.22 | 2022-04-06 | 2 | 486.71 | 1 | 328.86 | 18 | SO46638 | 2022-04-13 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46639_8 | 7CDF-4BF8-8E | PO10527141970 | 19 | 284 | 327 | 9 | 480 | 6 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 8 | SO46639 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46642_7 | 0A4E-465C-BB | PO551133122 | 100 | 283 | 327 | 9 | 4 | 4 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 7 | SO46642 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46643_16 | 49E8-4C7A-85 | PO899110603 | 100 | 289 | 327 | 9 | 290 | 1 | 845.63 | 2022-04-18 | 2818.76 | 49.33 | 2022-04-06 | 12 | 486.71 | 1 | 1973.13 | 16 | SO46643 | 2022-04-13 | 157.85 | 5840.48 | 234.90 | 0.30 |
SO46650_3 | 85DE-4E77-BD | PO2581114875 | 100 | 282 | 327 | 9 | 698 | 1 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 3 | SO46650 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46652_27 | D7E0-44F6-86 | PO3509195138 | 36 | 292 | 327 | 9 | 139 | 7 | 563.75 | 2022-04-18 | 1879.18 | 32.89 | 2022-04-06 | 8 | 486.71 | 1 | 1315.42 | 27 | SO46652 | 2022-04-13 | 105.23 | 3893.65 | 234.90 | 0.30 |
SO46654_10 | 2FEC-47CC-84 | PO3741124832 | 100 | 285 | 327 | 9 | 404 | 5 | 140.94 | 2022-04-18 | 469.79 | 8.22 | 2022-04-06 | 2 | 486.71 | 1 | 328.86 | 10 | SO46654 | 2022-04-13 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46660_27 | CF24-45E2-9D | PO5626129733 | 100 | 283 | 327 | 9 | 166 | 4 | 1127.51 | 2022-04-18 | 3758.35 | 65.77 | 2022-04-06 | 16 | 486.71 | 1 | 2630.85 | 27 | SO46660 | 2022-04-13 | 210.47 | 7787.31 | 234.90 | 0.30 |
SO46662_20 | 07F7-472E-AC | PO6467187386 | 100 | 281 | 327 | 9 | 660 | 3 | 281.88 | 2022-04-18 | 939.59 | 16.44 | 2022-04-06 | 4 | 486.71 | 1 | 657.71 | 20 | SO46662 | 2022-04-13 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO46663_18 | 0EA2-42AA-A4 | PO6409112370 | 100 | 283 | 327 | 9 | 292 | 4 | 281.88 | 2022-04-18 | 939.59 | 16.44 | 2022-04-06 | 4 | 486.71 | 1 | 657.71 | 18 | SO46663 | 2022-04-13 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO46664_9 | B900-4D0D-AF | PO6235159004 | 100 | 281 | 327 | 9 | 431 | 3 | 140.94 | 2022-04-18 | 469.79 | 8.22 | 2022-04-06 | 2 | 486.71 | 1 | 328.86 | 9 | SO46664 | 2022-04-13 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46666_1 | 1A94-4D1F-AF | PO6699130779 | 100 | 281 | 327 | 9 | 234 | 2 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 1 | SO46666 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46667_1 | D3CD-4A6E-94 | PO7105131549 | 100 | 286 | 327 | 9 | 668 | 1 | 140.94 | 2022-04-18 | 469.79 | 8.22 | 2022-04-06 | 2 | 486.71 | 1 | 328.86 | 1 | SO46667 | 2022-04-13 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46669_5 | 7080-4FDD-BD | PO8410183627 | 98 | 288 | 327 | 9 | 538 | 10 | 1197.97 | 2022-04-18 | 3993.25 | 69.88 | 2022-04-06 | 17 | 486.71 | 1 | 2795.27 | 5 | SO46669 | 2022-04-13 | 223.62 | 8274.01 | 234.90 | 0.30 |
SO46672_28 | FFCF-4848-99 | PO9831178966 | 100 | 285 | 327 | 9 | 81 | 5 | 1057.04 | 2022-04-18 | 3523.46 | 61.66 | 2022-04-06 | 15 | 486.71 | 1 | 2466.42 | 28 | SO46672 | 2022-04-13 | 197.31 | 7300.60 | 234.90 | 0.30 |
SO46675_7 | 1ED0-48BC-93 | PO10237173444 | 100 | 287 | 327 | 9 | 41 | 4 | 211.41 | 2022-04-18 | 704.69 | 12.33 | 2022-04-06 | 3 | 486.71 | 1 | 493.28 | 7 | SO46675 | 2022-04-13 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46933_25 | 4D88-4B51-BF | PO19546168601 | 100 | 285 | 327 | 9 | 206 | 5 | 211.41 | 2022-05-19 | 704.69 | 12.33 | 2022-05-07 | 3 | 486.71 | 1 | 493.28 | 25 | SO46933 | 2022-05-14 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46936_14 | 95A0-4327-AA | PO19227121833 | 19 | 284 | 327 | 9 | 210 | 6 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 14 | SO46936 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46940_7 | 6ADC-4363-B3 | PO18705126181 | 19 | 291 | 327 | 9 | 479 | 6 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 7 | SO46940 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46943_13 | 6F43-4A10-80 | PO18560122957 | 100 | 285 | 327 | 9 | 531 | 5 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 13 | SO46943 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46948_11 | B040-4261-B3 | PO18386128096 | 100 | 281 | 327 | 9 | 558 | 2 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 11 | SO46948 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46953_9 | C650-4C32-BE | PO17603154442 | 19 | 284 | 327 | 9 | 12 | 6 | 1197.97 | 2022-05-19 | 3993.25 | 69.88 | 2022-05-07 | 17 | 486.71 | 1 | 2795.27 | 9 | SO46953 | 2022-05-14 | 223.62 | 8274.01 | 234.90 | 0.30 |
SO46956_8 | 158F-43CB-95 | PO16849143827 | 100 | 281 | 327 | 9 | 198 | 3 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 8 | SO46956 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46959_55 | 9007-4F97-9C | PO16733197949 | 19 | 291 | 327 | 9 | 533 | 6 | 281.88 | 2022-05-19 | 939.59 | 16.44 | 2022-05-07 | 4 | 486.71 | 1 | 657.71 | 55 | SO46959 | 2022-05-14 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO46960_8 | F05E-41EB-90 | PO16762181648 | 100 | 282 | 327 | 9 | 259 | 4 | 140.94 | 2022-05-19 | 469.79 | 8.22 | 2022-05-07 | 2 | 486.71 | 1 | 328.86 | 8 | SO46960 | 2022-05-14 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46964_39 | B3E6-43CC-A2 | PO15689139014 | 100 | 283 | 327 | 9 | 328 | 4 | 352.35 | 2022-05-19 | 1174.49 | 20.55 | 2022-05-07 | 5 | 486.71 | 1 | 822.14 | 39 | SO46964 | 2022-05-14 | 65.77 | 2433.53 | 234.90 | 0.30 |
SO46965_9 | C9A7-4125-95 | PO15921113146 | 100 | 287 | 327 | 9 | 77 | 4 | 140.94 | 2022-05-19 | 469.79 | 8.22 | 2022-05-07 | 2 | 486.71 | 1 | 328.86 | 9 | SO46965 | 2022-05-14 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46968_3 | 280B-4350-80 | PO15254133264 | 100 | 281 | 327 | 9 | 377 | 3 | 211.41 | 2022-05-19 | 704.69 | 12.33 | 2022-05-07 | 3 | 486.71 | 1 | 493.28 | 3 | SO46968 | 2022-05-14 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO46978_1 | A71B-4A08-A1 | PO14007134254 | 100 | 289 | 327 | 9 | 56 | 1 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 1 | SO46978 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46980_12 | FAA2-449B-99 | PO13572170679 | 100 | 287 | 327 | 9 | 527 | 3 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 12 | SO46980 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46981_29 | 22E4-4440-81 | PO13427119728 | 100 | 292 | 327 | 9 | 638 | 7 | 986.57 | 2022-05-19 | 3288.56 | 57.55 | 2022-05-07 | 14 | 486.71 | 1 | 2301.99 | 29 | SO46981 | 2022-05-14 | 184.16 | 6813.89 | 234.90 | 0.30 |
SO46983_9 | 7464-4EB3-B6 | PO13311118060 | 100 | 292 | 327 | 9 | 301 | 7 | 281.88 | 2022-05-19 | 939.59 | 16.44 | 2022-05-07 | 4 | 486.71 | 1 | 657.71 | 9 | SO46983 | 2022-05-14 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO46986_7 | A56F-42B9-BB | PO12383199580 | 100 | 281 | 327 | 9 | 89 | 2 | 281.88 | 2022-05-19 | 939.59 | 16.44 | 2022-05-07 | 4 | 486.71 | 1 | 657.71 | 7 | SO46986 | 2022-05-14 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO46988_29 | 2D2E-4EC3-AC | PO12499171502 | 100 | 282 | 327 | 9 | 78 | 4 | 916.10 | 2022-05-19 | 3053.66 | 53.44 | 2022-05-07 | 13 | 486.71 | 1 | 2137.56 | 29 | SO46988 | 2022-05-14 | 171.01 | 6327.19 | 234.90 | 0.30 |
SO46992_6 | C958-4FD6-A0 | PO11745117547 | 100 | 282 | 327 | 9 | 97 | 4 | 140.94 | 2022-05-19 | 469.79 | 8.22 | 2022-05-07 | 2 | 486.71 | 1 | 328.86 | 6 | SO46992 | 2022-05-14 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46995_1 | 9CEA-4AC3-95 | PO11542113352 | 100 | 285 | 327 | 9 | 62 | 5 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 1 | SO46995 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO46996_10 | 775B-42D6-A5 | PO11571149031 | 100 | 285 | 327 | 9 | 512 | 5 | 140.94 | 2022-05-19 | 469.79 | 8.22 | 2022-05-07 | 2 | 486.71 | 1 | 328.86 | 10 | SO46996 | 2022-05-14 | 26.31 | 973.41 | 234.90 | 0.30 |
SO46997_13 | 9714-4035-90 | PO11020181604 | 19 | 284 | 327 | 9 | 336 | 6 | 281.88 | 2022-05-19 | 939.59 | 16.44 | 2022-05-07 | 4 | 486.71 | 1 | 657.71 | 13 | SO46997 | 2022-05-14 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO47001_25 | DD9D-4987-9E | PO10121150577 | 100 | 281 | 327 | 9 | 684 | 2 | 422.81 | 2022-05-19 | 1409.38 | 24.66 | 2022-05-07 | 6 | 486.71 | 1 | 986.57 | 25 | SO47001 | 2022-05-14 | 78.93 | 2920.24 | 234.90 | 0.30 |
SO47009_12 | 8F7C-4372-A2 | PO1508115971 | 98 | 288 | 327 | 9 | 430 | 10 | 140.94 | 2022-05-19 | 469.79 | 8.22 | 2022-05-07 | 2 | 486.71 | 1 | 328.86 | 12 | SO47009 | 2022-05-14 | 26.31 | 973.41 | 234.90 | 0.30 |
SO47011_14 | 808A-4138-A9 | PO1769173090 | 100 | 281 | 327 | 9 | 540 | 2 | 211.41 | 2022-05-19 | 704.69 | 12.33 | 2022-05-07 | 3 | 486.71 | 1 | 493.28 | 14 | SO47011 | 2022-05-14 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO47012_10 | 5043-4C8B-B3 | PO1914167487 | 19 | 284 | 327 | 9 | 66 | 6 | 775.16 | 2022-05-19 | 2583.87 | 45.22 | 2022-05-07 | 11 | 486.71 | 1 | 1808.71 | 10 | SO47012 | 2022-05-14 | 144.70 | 5353.77 | 234.90 | 0.30 |
SO47018_32 | E622-43B1-98 | PO2523197473 | 100 | 287 | 327 | 9 | 167 | 4 | 634.22 | 2022-05-19 | 2114.07 | 37.00 | 2022-05-07 | 9 | 486.71 | 1 | 1479.85 | 32 | SO47018 | 2022-05-14 | 118.39 | 4380.36 | 234.90 | 0.30 |
SO47027_45 | 1A9C-4166-A7 | PO3480112515 | 100 | 283 | 327 | 9 | 436 | 4 | 493.28 | 2022-05-19 | 1644.28 | 28.77 | 2022-05-07 | 7 | 486.71 | 1 | 1151.00 | 45 | SO47027 | 2022-05-14 | 92.08 | 3406.95 | 234.90 | 0.30 |
SO47032_8 | 090F-4070-AA | PO4553172367 | 100 | 282 | 327 | 9 | 313 | 4 | 211.41 | 2022-05-19 | 704.69 | 12.33 | 2022-05-07 | 3 | 486.71 | 1 | 493.28 | 8 | SO47032 | 2022-05-14 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO47033_51 | 2797-46ED-BB | PO4727113716 | 100 | 286 | 327 | 9 | 343 | 1 | 281.88 | 2022-05-19 | 939.59 | 16.44 | 2022-05-07 | 4 | 486.71 | 1 | 657.71 | 51 | SO47033 | 2022-05-14 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO47034_36 | A5AA-46C3-92 | PO4843149248 | 100 | 287 | 327 | 9 | 257 | 4 | 281.88 | 2022-05-19 | 939.59 | 16.44 | 2022-05-07 | 4 | 486.71 | 1 | 657.71 | 36 | SO47034 | 2022-05-14 | 52.62 | 1946.83 | 234.90 | 0.30 |
SO47041_24 | C543-4932-83 | PO5771188676 | 100 | 282 | 327 | 9 | 79 | 3 | 493.28 | 2022-05-19 | 1644.28 | 28.77 | 2022-05-07 | 7 | 486.71 | 1 | 1151.00 | 24 | SO47041 | 2022-05-14 | 92.08 | 3406.95 | 234.90 | 0.30 |
SO47054_23 | E4B1-4C58-AE | PO7627150376 | 100 | 286 | 327 | 9 | 433 | 1 | 211.41 | 2022-05-19 | 704.69 | 12.33 | 2022-05-07 | 3 | 486.71 | 1 | 493.28 | 23 | SO47054 | 2022-05-14 | 39.46 | 1460.12 | 234.90 | 0.30 |
SO47055_39 | BF62-4954-A7 | PO7453164163 | 100 | 281 | 327 | 9 | 108 | 2 | 1338.91 | 2022-05-19 | 4463.04 | 78.10 | 2022-05-07 | 19 | 486.71 | 1 | 3124.13 | 39 | SO47055 | 2022-05-14 | 249.93 | 9247.43 | 234.90 | 0.30 |
SO47061_10 | 58AC-406C-9C | PO8584111730 | 98 | 288 | 327 | 9 | 592 | 10 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 10 | SO47061 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO47066_13 | 5E42-48DE-80 | PO8816154123 | 100 | 289 | 327 | 9 | 218 | 1 | 70.47 | 2022-05-19 | 234.90 | 4.11 | 2022-05-07 | 1 | 486.71 | 1 | 164.43 | 13 | SO47066 | 2022-05-14 | 13.15 | 486.71 | 234.90 | 0.30 |
SO47067_19 | DDEC-4319-8A | PO9512118933 | 100 | 285 | 327 | 9 | 135 | 5 | 140.94 | 2022-05-19 | 469.79 | 8.22 | 2022-05-07 | 2 | 486.71 | 1 | 328.86 | 19 | SO47067 | 2022-05-14 | 26.31 | 973.41 | 234.90 | 0.30 |
Generated 2024-05-06 18:19:54.282 UTC